package org.csu.mypetstore.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.csu.mypetstore.domain.PO.Product;

public interface ProductMapper extends BaseMapper<Product> {

//    @Select("SELECT PRODUCTID,NAME,DESCN as description,CATEGORY as categoryId FROM PRODUCT WHERE CATEGORY=#{categoryId}")
//    public List<Product> getProductListByCategory(String categoryId);
//
//    @Select("SELECT PRODUCTID,NAME,DESCN as description,CATEGORY as categoryId FROM PRODUCT WHERE PRODUCTID = #{productId}")
//    public Product getProduct(String productId);
//
//    @Select("SELECT PRODUCTID,NAME,DESCN as description,CATEGORY as categoryId from PRODUCT WHERE lower(name) like #{keywords}")
//    public List<Product> searchProductList(String keywords);
}
